Healthcare Metric Source Review Decisions

Read-only decision board for Healthcare metric sources, field mapping, extractor QA, rollup inclusion, and publishing readiness.

Page version: 2026-05-13-v7-promotion-checklist

Mode: Read-only. This page does not edit CSV files, run extractors, or change public data. Use it to make source decisions visible before adding write controls.

Current Decision Summary

Rollup Status

not found

Current public dashboard rollup state.

Decision Ledger

Not built yet

Optional CSV ledger for durable source-review decisions.

Active Metrics

CMS NHE, Census coverage, and BLS medical-care CPI are in the active rollup.

Promotion Checklist

Not built yet

HC-MET-004 gates for candidate display and possible later rollup promotion.

Active Automated Source Decisions

These are the three sources currently integrated into the Healthcare metrics rollup. Future candidates should not be treated as dashboard failures until they pass these gates.

Metric ID	Source	Source Review Row	Stage	Decision	QA	Publication Use	Next Action	Caution
HC-MET-001	CMS National Health Expenditures	Row 13	ACTIVE	Keep in active rollup	PASS	Internal dashboard context; candidate for public beta after review	Keep monitoring row mapping and CMS workbook format.	Measures system spending, not care quality or household affordability by itself.
HC-MET-002	BLS Medical Care CPI	Row 3	ACTIVE WITH CAUTION	Keep in active rollup with stale-data warning	CHECK	Internal dashboard context only while BLS API is rate-limited	Preserve last good value; rerun after BLS daily limit clears.	Current value may be stale because BLS API threshold was reached.
HC-MET-003	Census Health Insurance Coverage	Row 26	ACTIVE	Keep in active rollup	PASS	Internal dashboard context; candidate for public beta after review	Keep monitoring annual Census table structure.	Measures insurance coverage status, not coverage adequacy or cost burden.

Reviewed Candidate Source Decisions

These sources have been inspected or have review-only extractors, but they are not active Healthcare rollup metrics yet.

Metric ID	Source	Source Review Row	Stage	Decision	QA	Publication Use	Next Action	Caution
HC-MET-004	CDC/NCHS NHIS Adult Summary Health Statistics	HC-CAND-004 / dataset 25m4-6qqq	REVIEWED CANDIDATE	Recommend paired/caution definition; do not add to active rollup yet	CHECK	Review-only candidate; not active dashboard rollup	Approve or revise the paired/caution source definition; then build a dashboard candidate card before active rollup promotion.	Post-2019 adult-only NHIS source. Do not silently merge with the 1997-2018 all-person Health, United States series.

Source Decision Gates

Gate	Question	Pass Standard	Evidence
1. Source Authority	Is the source official, reputable, stable, and relevant?	Government/statistical source preferred; exact URL recorded.	Source review row, URL, access notes.
2. Field Mapping	Can the metric value be extracted consistently?	Workbook/API fields mapped; units and derivations documented.	QA summary, mapping notes, observation CSV.
3. Extractor QA	Does the extractor produce current JSON, history, observations, and QA summary?	PASS or defensible CHECK; no destructive overwrite during source outage.	QA JSON, QA summary text, history JSONL.
4. Rollup Inclusion	Should the metric be included in healthcare_metrics_current.json?	Data is meaningful, explainable, and not misleading.	Rollup summary and dashboard preview.
5. Publishing Decision	Can the metric appear on a public page?	Public meaning, caution language, status labels, and freshness are acceptable.	Publishing QA page decision.

Decision Ledger Files

File	Status	Path	Purpose
Source Decisions CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_metric_source_decisions.csv	Optional durable decision ledger. Recommended before adding write controls.
Source Decisions Template CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_metric_source_decisions_template.csv	Safe starting template for source-review decisions.
Decision Vocabulary CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_metric_source_decision_vocabulary.csv	Standard decision codes used by the source-review ledger.
Field Mapping Decisions CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_metric_field_mapping_decisions.csv	Optional ledger for field mapping and extraction decisions.
Candidate Source Queue CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_metric_candidate_source_queue.csv	Candidate queue for future Healthcare metrics. These are not active rollup metrics until reviewed and automated.
HC-MET-004 Source Definition Decision CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_hc_met_004_source_definition_decision_v1.csv	Review-only source definition decision for the paired/caution NHIS adult cost-access measure.
HC-MET-004 Promotion Checklist CSV	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_hc_met_004_promotion_decision_checklist.csv	Promotion gates for public candidate display and later active rollup consideration.
HC-MET-004 Promotion Checklist Note	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_hc_met_004_promotion_decision_checklist_v1.txt	Plain-English promotion guidance and current recommendation.
HC-MET-004 NHIS Review Summary	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_cdc_nhis_adult_cost_access_metric_review_summary.txt	Review-only metric summary for the newer 2019-2024 NHIS adult cost-access source.
HC-MET-004 Historical HUS Review Summary	NOT BUILT YET	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_cdc_unmet_need_cost_metric_review_summary.txt	Review-only summary for the older 1997-2018 all-person HUS unmet-need source.
Healthcare Metrics Rollup JSON	MISSING	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\40 - Metrics\App_Data\healthcare_metrics_current.json	Public dashboard-facing rollup file.
Full Run Summary	MISSING	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_metrics_all_run_summary.txt	Latest full pipeline run summary.
Rollup Summary	MISSING	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_metrics_rollup_summary.txt	Latest rollup QA summary.

CSV Files Currently in Review Folder

G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review

Folder not found: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review

Latest QA Context

Metric	QA Line	Summary File
BLS Medical Care CPI	not found	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_bls_medical_care_cpi_metric_summary.txt
Census Health Insurance Coverage	not found	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_census_health_insurance_coverage_metric_summary.txt
CMS National Health Expenditures	not found	G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_cms_nhe_metric_summary.txt

Decision Vocabulary Preview

No decision vocabulary CSV found yet. Save healthcare_metric_source_decision_vocabulary.csv in the review folder to show standard source decision codes here.

Candidate Source Queue Preview

This queue is for future metrics only. Candidate rows should remain CANDIDATE_REVIEW or FIELD_MAPPING_NEEDED until an extractor exists and QA passes.

No candidate source queue CSV found yet. Save healthcare_metric_candidate_source_queue.csv in the review folder to preview future metric candidates here.

HC-MET-004 Review Summary Preview

This reviewed candidate has a current NHIS source path, but it remains outside the active rollup until the paired/caution definition is approved.

No HC-MET-004 NHIS review summary found yet. Run the review-only NHIS builder to create the summary.

HC-MET-004 Source Definition Decision Preview

No HC-MET-004 source-definition decision CSV found yet. Save healthcare_hc_met_004_source_definition_decision_v1.csv in the review folder to preview it here.

HC-MET-004 Promotion Decision Checklist Preview

This checklist is the gate between a reviewed candidate, a public candidate card, and any later active rollup promotion.

No HC-MET-004 promotion checklist CSV found yet. Save healthcare_hc_met_004_promotion_decision_checklist.csv in the review folder to preview it here.

Recommended Next Actions

Back up the current source-decision CSV before replacing it with the V2 ledger that includes HC-MET-004 as a reviewed candidate.
Approve or revise the HC-MET-004 paired/caution source definition.
Keep HC-MET-004 out of the active rollup until the public dashboard wording and caution language are approved.
Use the HC-MET-004 promotion checklist to approve public candidate display only, or to keep the metric in review.
Do not promote HC-MET-004 into the active rollup until the paired/caution definition and public wording are approved.

Decision CSV Preview

No decision CSV found yet. This is acceptable. Use the template deliverable first, review the columns, then rename the template to the live CSV only when ready.